<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <meta name="renderer" content="webkit"/>
  <meta name="force-rendering" content="webkit"/>
  <meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1"/>
  <title>当日游戏数据</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">

  <link rel="stylesheet" href="/bower_components/bootstrap/dist/css/bootstrap.min.css">
  <link rel="stylesheet" href="/bower_components/font-awesome/css/font-awesome.min.css">
  <link rel="stylesheet" href="/bower_components/Ionicons/css/ionicons.min.css">
  <link rel="stylesheet" href="/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
  <link rel="stylesheet" href="/dist/css/AdminLTE.min.css">
  <link rel="stylesheet" href="/dist/css/skins/_all-skins.min.css">

  <link rel="stylesheet" href="/dist/js/datepicker/css/datepicker.css">

  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

  <!-- Google Font -->
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">

  <!--头部-->
  <header id="headerDiv" class="main-header">
    <!--#include  file="/pages/admin/header.html"-->
  </header>

  <!--左侧边栏 -->
  <aside id="sidebarDiv" class="main-sidebar">
    <!--#include  file="/pages/admin/sidebar.html"-->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        <small>当日游戏数据</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="javascript:void(0);"><i class="fa fa-dashboard"></i> 游戏指标分析</a></li>
        <li><a href="javascript:void(0);">当日游戏数据</a></li>
      </ol>
    </section>



    <!-- Main content -->
    <section class="content">
      <div class="row">
        <div class="col-xs-12">
          <div class="box">
            <div class="box-header">
              <!--<button class="btn btn-success" onclick="download()"><i class="fa fa-file-excel-o"></i>&nbsp;导出excel</button>-->
              <form role="form" class="form-inline pull-right">
                <label class="control-label">搜索:</label>


                <!--<div class="form-group">
                  <input id="searchDate" type="text" class="form-control" placeholder="日期">
                </div>-->

                <div class="form-group">
                  <div class="c-datepicker-date-editor J-datepicker-range-day mt10">
                    <i class="c-datepicker-range__icon kxiconfont icon-clock"></i>
                    <input id="startDate" placeholder="开始日期" name="" class="c-datepicker-data-input only-date" value="">
                    <span class="c-datepicker-range-separator">~</span>
                    <input id="endDate" placeholder="结束日期" name="" class="c-datepicker-data-input only-date" value="">
                  </div>
                </div>


                <!--<div class="form-group">
                  <select id="sortValue" class="form-control m-b">
                    <option value="">默认排序</option>
                    <option value="day">日期</option>
                    <option value="views">浏览量</option>
                    <option value="num">结算量</option>
                    <option value="deduction">扣量</option>
                    <option value="sumpay">预算支出</option>
                    <option value="sumprofit">盈利</option>
                  </select>
                </div>-->

                <div class="form-group">
                  <select id="searchKey" class="form-control m-b">
                    <option value="lyid">联运平台渠道id</option>
                    <option value="game">游戏名称</option>
                  </select>
                </div>
                <div class="form-group">
                  <div class="input-group">
                    <input id="searchValue" type="text" class="form-control">
                    <span class="input-group-btn">
                        <button type="button" class="btn btn-primary" onclick="search();"><i class="fa fa-search"></i></button>
                    </span>
                  </div>
                </div>
              </form>
            </div>


            <div class="box-body table-responsive">
              <table id="datatable"  class="table small table-bordered table-hover table-striped ">
                <thead>
                <tr>
                  <th style=" white-space:nowrap">所属站长 / ID</th>
                  <th style=" white-space:nowrap">所属素材 / ID</th>
                  <th style=" white-space:nowrap">子渠道id</th>
                  <th style=" white-space:nowrap">日期</th>
                  <th style=" white-space:nowrap">游戏名称</th>
                  <th style=" white-space:nowrap">首次时长</th>
                  <th style=" white-space:nowrap">登陆</th>
                  <th style=" white-space:nowrap">新增</th>
                  <th style=" white-space:nowrap">充值</th>
                  <th style=" white-space:nowrap">日活</th>
                  <th style=" white-space:nowrap">次日留存</th>
                  <th style=" white-space:nowrap">7日留存</th>
                  <th style=" white-space:nowrap">30日充值率</th>
                  <th style=" white-space:nowrap">平均消费</th>
                  <th style=" white-space:nowrap">次日LTV</th>
                  <th style=" white-space:nowrap">7日LTV</th>
                  <th style=" white-space:nowrap">登录付费人数</th>
                  <th style=" white-space:nowrap">登录付费率</th>
                  <th style=" white-space:nowrap">登录充值</th>
                  <th style=" white-space:nowrap">新增付费人数</th>
                  <th style=" white-space:nowrap">新增付费率</th>
                  <th style=" white-space:nowrap">新增充值</th>
                  <th style=" white-space:nowrap">充值金额</th>
                  <th style=" white-space:nowrap">累计充值</th>
                  <th style=" white-space:nowrap">投放金额</th>
                  <th style=" white-space:nowrap">累计投放金额</th>
                </tr>
                </thead>
                <tbody>
                </tbody>
              </table>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->



        </div>
      </div>
    </section>
    <!-- /.content -->

  </div>
  <!-- /.content-wrapper -->
  <!--底部-->
  <footer id="footerDiv" class="main-footer">
    <!--#include  file="/pages/admin/footer.html"-->
  </footer>

  <!-- Control Sidebar -->
  <!-- /.control-sidebar -->
  <!-- Add the sidebar's background. This div must be placed
       immediately after the control sidebar -->
  <div class="control-sidebar-bg"></div>
</div>
<!-- ./wrapper -->
<script src="/bower_components/jquery/dist/jquery.min.js"></script>
<script src="/bower_components/morris.js/morris.min.js"></script>
<script src="/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="/bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script src="/bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<script src="/bower_components/fastclick/lib/fastclick.js"></script>
<script src="/dist/js/adminlte.min.js"></script>
<script src="/dist/js/store.min.js"></script>
<script src="/dist/js/layer/layer.js"></script>
<script src="/dist/js/laydate/laydate.js"></script>

<script src="/dist/js/datepicker/js/plugins/moment.min.js"></script>
<script src="/dist/js/datepicker/js/datepicker.all.js"></script>


<script>
    var dataMap={};
    var datatable;
    $(function () {
        var DATAPICKERAPI = {

            shortcutMonth: function () {
                // 当月
                var nowDay = moment().get('date');
                var prevMonthFirstDay = moment().subtract(1, 'months').set({ 'date': 1 });
                var prevMonthDay = moment().diff(prevMonthFirstDay, 'days');
                return {
                    now: '-' + nowDay + ',0',
                    prev: '-' + prevMonthDay + ',-' + nowDay
                }
            },

            // 快捷选项option
            rangeShortcutOption1: [
                {
                    name: '今天',
                    day: '0,0'
                },
                {
                    name: '昨天',
                    day: '-1,-1'
                },
                {
                    name: '近7天',
                    day: '-8,-1'
                }, {
                    name: '最近30天',
                    day: '-31,-1'
                }]

        };
        //年月日范围
        $('.J-datepicker-range-day').datePicker({
            hasShortcut: true,
            format: 'YYYY-MM-DD',
            isRange: true,
            shortcutOptions: DATAPICKERAPI.rangeShortcutOption1
        });

        //tab1
        datatable = $("#datatable").DataTable({
           // 'aLengthMenu' : [1000],
            'scrollCollapse': true,//
            'stateSave': false,//保存配置状态
            'processing': true, // 显示loading
            'paging': false,
            'lengthChange': false,
            'searching': false,// 取消搜索框
            'ordering': false,// 取消字段排序
            'info': false,
            'autoWidth': false,
            'deferRender': true,
            'serverSide': true, // ajax请求时必须写本项
            // 'pagingType' : 'full_numbers',
            'ajax': { // ajax请求
                'type': "POST",
                'url': "/lmgame/gamedata/list",
                'data': function (d) {
                    d.startDate=$("#startDate").val();
                    d.endDate=$("#endDate").val();
                    d.sortValue = $("#sortValue").val();//排序
                    d.plantype=$("#plantype").val();
                    d.searchKey = $("#searchKey").val();
                    d.searchValue = $("#searchValue").val();
                    d.type = 1;
                    return d;
                },
                "error": function (xhr, ts, et) { //XMLHttpRequest, textStatus, errorThrown
                    if (xhr.status === 400) {
                        window.location.href = "/pages/admin/login.html";
                    }
                    if (xhr.status === 403) {
                        window.location.href = "/403.html";
                    }
                }
            },
            'columns': [ // data数据绑定对应列
                {"data": null},
                {
                    "class":          'notab',
                    "data":           null
                },
                {"data": "lyid"},
                {
                    "class":          'notab',
                    "data":           "day"
                },
                {
                    "class":          'notab',
                    "data":           "game"
                },
                {"data": "first_time"},
                {"data": "login_count"},
                {"data": "register_count"},
                {"data": "recharge_count"},
                {"data": "day_activity_dau"},
                {"data": "dr1"},
                {"data": "dr7"},
                {"data": "recharge_rate30"},
                {"data": "avg_aurp"},
                {"data": "ltv1"},
                {"data": "ltv7"},
                {"data": "login_recharge_count"},
                {"data": "login_recharge_rate"},
                {"data": "login_recharge"},
                {"data": "register_recharge_count"},
                {"data": "register_recharge_rate"},
                {"data": "register_recharge"},
                {"data": "recharge"},
                {"data": "recharge_sum"},
                {"data": "invested_amount"},
                {"data": "invested_amount_sum"}
            ],
            "columnDefs": [
                {
                    targets: 0,
                    render: function (a) {
                       return a.username + " / " + a.id;
                    }
                },
                {
                    targets: 1,
                    render: function (a) {
                        return a.sucai_name + " / " + a.sucai_id;
                    }
                },
                {
                    targets: 5,
                    render: function (a) {
                        return a.toFixed(2);
                    }
                },
                {
                    targets: 10,
                    render: function (a) {
                        return (a*100).toFixed(2)+"%";
                    }
                },
                {
                    targets: 11,
                    render: function (a) {
                        return (a*100).toFixed(2)+"%";
                    }
                },
                {
                    targets: 12,
                    render: function (a) {
                        return (a*100).toFixed(2)+"%";
                    }
                },
                // {
                //     targets: 14,
                //     render: function (a) {
                //         return (a).toFixed(2);
                //     }
                // },
                // {
                //     targets: 15,
                //     render: function (a) {
                //         return (a).toFixed(2);
                //     }
                // },
                {
                    targets: 17,
                    render: function (a) {
                        return (a*100).toFixed(2)+"%";
                    }
                },
                {
                    targets: 20,
                    render: function (a) {
                        return (a*100).toFixed(2)+"%";
                    }
                }
            ],
            "createdRow": function (row, data, index) {
                dataMap[data.id] = data;
            }
        });
    });


    function search() {
        datatable.ajax.reload(false);
    }

    var parseParam=function(param, key){
        var paramStr="";
        if(param instanceof String||param instanceof Number||param instanceof Boolean){
            paramStr+="&"+key+"="+encodeURIComponent(param);
        }else{
            $.each(param,function(i){
                var k=key==null?i:key+(param instanceof Array?"["+i+"]":"."+i);
                paramStr+='&'+parseParam(this, k);
            });
        }
        return paramStr.substr(1);
    };

    function download() {
        let d = {};
        d.startDate=$("#startDate").val();
        d.endDate=$("#endDate").val();
        d.sortValue = $("#sortValue").val();//排序
        d.plantype=$("#plantype").val();
        d.searchKey = $("#searchKey").val();
        d.searchValue = $("#searchValue").val();
        d.type = 1;
        let url = "/lmgame/data/excel?"+parseParam(d);
        window.location.href = url;
    }
</script>

</body>
</html>
